if exists(select name from sysobjects where name = 'sp_LoaiSanPhamGetInfo')
	drop proc sp_LoaiSanPhamGetInfo
go
/*-- =============================================
	Created by: HP
	Created on: 2014-03-14 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_LoaiSanPhamGetInfo.sql
*/-- =============================================

CREATE PROCEDURE sp_LoaiSanPhamGetInfo
			
	@Id      		INT
AS
BEGIN	
	SELECT
		a.[Id],
		a.[TenNhomSanPham],
		a.[IdCha],
		a.[ThuTu],
		a.[TrangThai]
	FROM
		LoaiSanPham a
	WHERE
		    a.[Id]       = @Id;
END
GO
